{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "content = pd.read_csv(\"alltopcontent.csv\")\n",
    "content = content[[\"title\", \"total_shares\", \"url\"]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "randomcontent = content.sample(100000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                                    title  total_shares  \\\n",
      "124419  These 6 women got written out of tech history....         73821   \n",
      "12          Loyal Employees are your Most Valuable Asset!       7374965   \n",
      "102639  Georgia Democrat aims to be nation’s first fem...         85356   \n",
      "21523   This Black Cosplayer Is Breaking The Racial Bo...        256956   \n",
      "22324             52 Week Money Saving Challenge For 2015        250743   \n",
      "\n",
      "                                                      url  \n",
      "124419  https://www.upworthy.com/these-6-women-got-wri...  \n",
      "12      https://www.linkedin.com/pulse/loyal-employees...  \n",
      "102639  https://www.washingtonpost.com/national/georgi...  \n",
      "21523   https://www.boredpanda.com/kiera-please-multi-...  \n",
      "22324   http://diycozyhome.com/52-week-money-saving-ch...  \n"
     ]
    }
   ],
   "source": [
    "print(randomcontent.head())\n",
    "docname = \"/Users/tessmcnulty/random100000labeled.csv\"\n",
    "randomcontent.to_csv(docname)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:root] *",
   "language": "python",
   "name": "conda-root-py"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
